Skip to main content

Create Dataset using CSV

  • From this document, you will learn to create a dataset in AIV, Moreover, you will learn to make a dataset using CSV(Comma-separated values).

What is CSV?

  • A comma-separated values file is a delimited text file that uses a comma to separate values & that file is a plain text file that contains a list of data. These files are often used for exchanging data between different application. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

  • Click here to know more about CSV files.

Objectives

  • Create dataset using CSV File

Prerequisites

  • For this example we are using employees.csv

Download csv.zip file from link given csv.zip

  • After downloading the zip file, add it into the AIV. To add it into AIV follow this Link.

Dataset using CSV: This video contains how to create Dataset using CSV in AIV.

Steps to create dataset using CSV

  1. Click on Hamburger Icon & go to Documents Tab.

    Docusaurus Slash Introduction

  2. In Documents tab Click on Shared Resource.

  3. In Shared Resource Click on upload, As shown in figure below:

    Docusaurus Slash Introduction

  4. When you click on Upload it will display a screen.

  5. In Upload Files upload a csv file, As shown in figure below:

    Docusaurus Slash Introduction

  6. Click on Upload button.

  7. You will get a message, As shown in figure below:

    Docusaurus Slash Introduction

  8. In Master Data Tab click on Dataset.

  9. Click on create dataset, As shown in figure below:

    Docusaurus Slash Introduction

  10. Enter following details in Create Dataset.

  • Name: Employee
  • Datasource: Existing Files
  • Select Employee.csv file in Available to selected.
  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on the Select from the center of the screen & then click on Preview and Submit button.

  3. You will see the Employee Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  4. Click on Hamburger menu > Dashboard section & open your dashboard.

    Docusaurus Slash Introduction

  1. From Right Vertical Menu Select the Table Widget icon for this example.

    Docusaurus Slash Introduction

info
  • Click here to know more about different dashboard widgets.
  1. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  2. Enter Following Details in edit box, As shown in figure below:

  • Dataset: Employee.ds
  • Select all the Field in Dataset Column.
  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and Save and Exit button.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

✒️To know more about how to create dataset using different sources follow below Links:-

Dataset using Excel

Dataset using JSON

Dataset using Flatfiles

Dataset using External sources

Dataset using Google BigQuery

Dataset using noSQL

Dataset using Join

Dataset using Union

Dataset using Server Script

Dataset using Client Script

Dataset using Stored Procedure

Dataset using View

Dataset using Simple Query

Dataset using Drag & Drop